﻿<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="rssDiscussion.aspx.vb" Inherits="Web_2._0_BMW___X6_Experts_Web_Application.rssDiscussion" ContentType="text/xml" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        #form1
        {
            font-size: medium;
            font-family: Calibri;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1">
    
    <HeaderTemplate>
    <rss version="2.0">
      <channel>
        <title>List of General Discussions</title>
        


        <description>
          <strong>***Maintenance Discussions***</strong>
          <br />
          <br />
        </description>
     </HeaderTemplate>

     <ItemTemplate>
     <item>
      
                                                 
            <discussionid><strong>Discussion ID: </strong><%# (DataBinder.Eval(Container.DataItem, "DiscussionID"))%></discussionid>                              
         <br />  
            <dtitle><strong>Discussion Title: </strong><%# DataBinder.Eval(Container.DataItem, "Title")%></dtitle>
            <br />  
            <datereated><strong>Date Created: </strong><%# DataBinder.Eval(Container.DataItem, "DateCreated")%></datereated>
                   <br />  
            <username><strong>Discussion Created by: </strong><%# (DataBinder.Eval(Container.DataItem, "Username"))%></username>
                                                
     
     <hr />

     </item>
     </ItemTemplate>


     <FooterTemplate>
      </channel>
    </rss>  
  </FooterTemplate>





    </asp:Repeater>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
        SelectCommand="SELECT Discussion.DiscussionID, Discussion.Title, Discussion.DateCreated, aspnet_Users.UserName FROM (Discussion INNER JOIN aspnet_Users ON Discussion.UserIDFK = aspnet_Users.UserId) ORDER BY Discussion.DiscussionID DESC">
    </asp:SqlDataSource>
    </form>
</body>
</html>
